package com.be.beadmin.device.entity;

import com.be.beadmin.common.entity.BaseEntity;
import lombok.Getter;
import lombok.Setter;

import java.util.ArrayList;
import java.util.List;
import java.util.Date;

import javax.persistence.*;

@Entity
@Getter
@Setter
@Table(name="t_de_tool_info")
public class ToolInfo extends BaseEntity{
    @Column(name = "identification",columnDefinition = "VARCHAR(50) COMMENT '唯一标识'  not null ")
    private String identification;

    @Column(name = "tool_name",columnDefinition = "VARCHAR(200) COMMENT '工具名称'")
    private String toolName;

    @Column(name = "tool_id",columnDefinition = "VARCHAR(20) COMMENT '工具编号'")
    private String toolId;

    @Column(name = "tool_type",columnDefinition = "VARCHAR(20) COMMENT '规格型号'")
    private String toolType;

    @Column(name = "manufacturer",columnDefinition = "VARCHAR(20) COMMENT '品牌'")
    private String manufacturer;

    /**
     * 100
     */
    @Column(name = "planed_life",columnDefinition = "float COMMENT '计划寿命'")
    private float planedLife;

    /**
     * 30
     */
    @Column(name = "used_life",columnDefinition = "float COMMENT '使用寿命'")
    private float usedLife;

    /**
     * 70
     */
    @Column(name = "remaining_life",columnDefinition = "float COMMENT '剩余寿命'")
    private float remainingLife;

    @Column(name = "qty",columnDefinition = "float COMMENT '数量'")
    private float qty;

    /**
     * 已领出，已报废，正常
     */
    @Column(name = "tool_state",columnDefinition = "VARCHAR(20) COMMENT '工具状态'")
    private String toolState;

    @Column(name = "takeaway_date",columnDefinition = "datetime COMMENT '领用日期'")
    private Date takeawayDate;

    @Column(name = "scrapped_date",columnDefinition = "datetime COMMENT '报废日期'")
    private Date scrappedDate;

    @Column(name = "location",columnDefinition = "VARCHAR(20) COMMENT '存储位置'")
    private String location;

    @Column(name = "contact",columnDefinition = "VARCHAR(20) COMMENT '联系人'")
    private String contact;

    @Column(name = "telephone",columnDefinition = "VARCHAR(20) COMMENT '联系方式'")
    private String telephone;

    @Column(name = "dept",columnDefinition = "VARCHAR(20) COMMENT '部门'")
    private String dept;

    @Column(name = "employee_id",columnDefinition = "VARCHAR(20) COMMENT '工号'")
    private String employeeId;

    @Column(name = "costcenter",columnDefinition = "VARCHAR(20) COMMENT '成本中心'")
    private String costcenter;

    @Column(name = "category",columnDefinition = "VARCHAR(20) COMMENT '设备类别'")
    private String category;

    @Column(name = "contract_id",columnDefinition = "VARCHAR(20) COMMENT '采购编号'")
    private String contractId;

    @Column(name = "contract_date",columnDefinition = "datetime COMMENT '采购日期'")
    private Date contractDate;

}
